package com.tgy.demo.utils;

import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;

/***
 * @ClassName: JdbcUtils
 * @Description:
 * @Auther: 送一一块二向箔
 * @Date: 21:29 2021/11/29
 * @version : V1.0
 */
public class JdbcUtils {
    private static String url = null;
    private static String username = null;
    private static String password = null;
    private static String drive = null;
    static{
        try{
            InputStream resourceAsStream = JdbcUtils.class.getClassLoader().getResourceAsStream("db.yml");
            Properties properties = new Properties();
            properties.load(resourceAsStream);
            url = properties.getProperty("url");
            username = properties.getProperty("username");
            password = properties.getProperty("password");
            drive = properties.getProperty("driver-class-name");
            Class.forName(drive);
            //1.驱动只用加载一次
        } catch (IOException | ClassNotFoundException e) {
            e.printStackTrace();
        }
        //获取连接
    }
    //获取连接
    public static Connection getConnection() throws SQLException {
        return DriverManager.getConnection(url,username,password);
    }
    //释放连接资源
    public static void release(Connection conn, Statement st, ResultSet rs){
        if (rs!=null) {
            try {
                rs.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if (st!=null) {
            try {
                st.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if (conn!=null) {
            try {
                conn.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }
}
